package com.lkd.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.lkd.entity.SkuClass;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * 商品类别表 Mapper 接口
 * </p>
 *
 * @author author
 * @since 2024-08-17
 */
@Mapper
public interface SkuClassMapper extends BaseMapper<SkuClass> {

    @Select("select count(1) from tb_sku s left join tb_sku_class sc on s.class_id=sc.class_id where s.class_id=#{classId}")
    Integer getSkuClassCount(Integer classId);
}
